Customizing Excel Document View Settings for PrizmDoc Server

PrizmDoc Server supports different view modes for rendering of Excel documents. To customize Excel view settings, edit the central configuration file. Modify the following parameters to adjust Excel viewing settings:

Example	Copy Code
fileTypes.excel.renderGridlines: true fileTypes.excel.renderOnlyPrintArea: false fileTypes.excel.renderHeadersAndFooters: true fileTypes.excel.renderHiddenContent: true

fileTypes.excel.renderGridlines – specifies whether or not the Excel gridlines in all worksheets of the workbook should be rendered.
fileTypes.excel.renderOnlyPrintArea – specifies whether the print areas defined in the Excel workbook are to be honored or not. When set to "true", only the content defined within the print areas will be rendered. When set to "false", the content that goes beyond print areas will be rendered as well.
fileTypes.excel.renderHeadersAndFooters – specifies whether or not headers and footers of an Excel workbook should be rendered. When set to "true", even if the original document is missing the headers and footers, a space for headers and footers shall be reserved when rendering an Excel document.
fileTypes.excel.renderHiddenContent – specifies whether or not the hidden rows, hidden columns, and whole spreadsheets that are hidden in the original Excel workbook are to be rendered.

The following configuration properties have been deprecated and will be removed in a future release. Alter these properties only if you are not using the central configuration file.

To customize Excel view settings using legacy configuration, edit the Watchdog configuration file located in the following default directories:

Windows: C:\Prizm\PCCIS\Watchdog\watchdog.config
Linux: /usr/share/prizm/pccis/Watchdog/watchdog.config

Modify the following parameters to adjust Excel viewing settings:

Example	Copy Code
"officeConversionService": { ... "excelRenderGridlines":true, "excelRenderOnlyPrintArea":false, "excelRenderHeadersAndFooters":true, "excelRenderHiddenContent":true ... },

excelRenderGridlines – specifies whether or not the Excel gridlines in all worksheets of the workbook should be rendered.
excelRenderOnlyPrintArea – specifies whether the print areas defined in Excel workbook are to be honored or not. When set to "true", only the content defined within the print areas will be rendered. When set to "false", the content that goes beyond print areas will be rendered as well.
excelRenderHeadersAndFooters – specifies whether or not headers and footers of an Excel workbook should be rendered. When set to "true", even if the original document is missing the headers and footers, a space for headers and footers shall be reserved when rendering an Excel document.
excelRenderHiddenContent – specifies whether or not the hidden rows, hidden columns, and whole spreadsheets that are hidden in the original Excel workbook are to be rendered.